Scriptbox - Find your Script, VBScript VBScripts VB-Script VB-Scripts Scripting

Loading

:: { Category } ::

0-9


	Search Options: Save a Table in an Access Database as a Spreadsheet Content of Save a Table in an Access Database as a Spreadsheet.vbs MD5 Hash: 6554243D0A2DE11812DDA5B06E4EDFE2
	Const acExport = 1 Const acSpreadsheetTypeExcel9 = 8 Set objAccess = CreateObject("Access.Application") objAccess.OpenCurrentDatabase "C:\Scripts\Test.mdb" objAccess.DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, _ "Employees", "C:\Scripts\Employees.xls", True

© 2008 - 2013 Boris Toll :: Scripts available: 6.481 :: :: scriptbox.toll.at :: :: powered by www.toll.at ::